/*
 * Copyright 2013 - 2020 Outworkers Ltd.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.outworkers.phantom.tables

import com.outworkers.phantom.dsl._

import scala.concurrent.Future

case class Article(
  id: UUID,
  name: String,
  orderId: Long
)

abstract class Articles extends Table[Articles, Article] {
  object id extends UUIDColumn with PartitionKey
  object name extends StringColumn
  object orderId extends LongColumn
}


abstract class ArticlesByAuthor extends Table[ArticlesByAuthor, Article] {
  object author_id extends UUIDColumn with PartitionKey
  object category extends UUIDColumn with PartitionKey
  object id extends UUIDColumn with PrimaryKey
  object name extends StringColumn
  object orderId extends LongColumn
}


case class User(id: UUID, name:String)

abstract class Users extends Table[Users, User] {
  object id extends UUIDColumn with PartitionKey
  object name extends StringColumn

  def getById(id: UUID): Future[Option[User]] = {
    select.where(_.id eqs id).one()
  }
}